All Questions
10 questions
7votes
3answers
1kviews
Prevent analytics from crashing the production database
At the core of my business (say, an online store) is a Postgres database that stores products and transactions. During day-to-day operations, the load on the database is not heavy. However, there is ...
2votes
2answers
1kviews
Storing unchangeable data in database vs in code
Hi I am trying to create a role based dynamic route authorization system on my NodeJS ExpressJS powered API server. Scenario: There will be some roles like Admin, StandardUser etc. and they can't be ...
1vote
2answers
75views
Architecture of "tags" for contacts in a marketing system and hard-coded IDs so functions can refer to them
I have these tables: contacts, tags, contact_tags. (contact_tags has columns contact_id and tag_id.) Administrators can manually create new tags via an internal website. Administrators can also ...
- 157
-2votes
2answers
148views
database/orm model design for contacts
I am building a internal crm which has contacts which are just people with first name, last name, email, phone etc. Contacts can be one or more types e.t.c. job candidates, hiring managers, customers, ...
- 109
2votes
1answer
682views
Which datastructure to use for temporary storage of intermittent and asynchronous sensor data?
Here an outline of the setup: Input data: I have several sources for sensor input data (GPS, and a bunch of other sensor data from different sources). All of those individual inputs consist of a ...
- 131
1vote
2answers
71views
Import configuration and relational data
Suppose that a user has multiple items. Each item would have complex configuration - multiple tables with relationships. Each configuration table would have an id and a item_id which is a FK to items ...
- 575
9votes
4answers
1kviews
Database design for fields that should be NOT NULL eventually, but may not yet have a value
I have encountered this problem a number of times. Let's say you have a large object that you want to store in the database. Perhaps it's a dating profile for a user, and it has 100 fields. All of ...
- 199
1vote
3answers
620views
Categorizing columns in a database table
I wanted to know how do people generically think of, in a data base table: Columns that people are expected to use mostly for grouping expectable of groupability. Columns that people are expected to ...
1vote
2answers
59views
Modify existing column or link to what the change is?
I am making a game. In this game people can modify a value of an object. Let's picture it like so. House is the object price is the value Mold is the modifier Should I reflect changes to the price ...
- 1,908
1vote
2answers
1kviews
Referential integrity in a database where tuples are not physically deleted
Many modern Relational Database Management Systems automatically support referential integrity, i.e. when you try to delete a tuple which has a reference (in the form of foreign key, for example), the ...
- 7,373
